﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Script.Serialization;
using CRMFramework;
using System.Text ;

namespace CRMWeb.WebServices.DataImport
{
    /// <summary>
    /// Summary description for PostDataFromMorganFinance
    /// </summary>
    public class PostDataFromMorganFinance : IHttpHandler
    {
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            string insertString = context.Request.Form["insertString"];
            InsertDataToCRMAppInfoByString(insertString);
        }

        public bool IsReusable
        {
            get
            {
                return false;
            }
        }

        private void InsertDataToCRMAppInfoByString(string insertString)
        {
            //ExecuteNonQuery
            DBhelper.ExecuteNonQuery(insertString);
        }

        private void InsertDataToCRMAppInfo(HttpContext context)
        {
            var para = new[] {
                            DBhelper.SetParameter("@app_ela",context.Request.QueryString["app_ela"]),
                            DBhelper.SetParameter("@app_FirstName1",context.Request.QueryString["app_FirstName1"]),
                            DBhelper.SetParameter("@app_FirstName2",context.Request.QueryString["app_FirstName2"]),
                            DBhelper.SetParameter("@app_MiddleName1", context.Request.QueryString["app_MiddleName1"]),
                            DBhelper.SetParameter("@app_MiddleName2", context.Request.QueryString["app_MiddleName2"]),

                            DBhelper.SetParameter("@app_Surname1", context.Request.QueryString["app_Surname1"] ),
                            DBhelper.SetParameter("@app_Surname2", context.Request.QueryString["app_Surname2"] ),
                            DBhelper.SetParameter("@app_NumberPeopleApplying", context.Request.QueryString["app_NumberPeopleApplying"] ),

                            DBhelper.SetParameter("@app_Filledform", context.Request.QueryString["app_Filledform"] ),
                            DBhelper.SetParameter("@app_ApplicantName", context.Request.QueryString["app_ApplicantName"] ),
                            DBhelper.SetParameter("@app_ExistingClient", context.Request.QueryString["app_ExistingClient"] ),

                            DBhelper.SetParameter("@app_LoanAmount", context.Request.QueryString["app_LoanAmount"] ),
                            DBhelper.SetParameter("@app_PreferredLoanPeriod", context.Request.QueryString["app_PreferredLoanPeriod"] ),
                            DBhelper.SetParameter("@app_Residency", context.Request.QueryString["app_Residency"] ),


                            DBhelper.SetParameter("@app_Residency2", context.Request.QueryString["app_Residency2"] ),
                            DBhelper.SetParameter("@app_ApplyWithSomeoneWhoOwns", context.Request.QueryString["app_ApplyWithSomeoneWhoOwns"] ),
                            DBhelper.SetParameter("@app_AoP", context.Request.QueryString["app_AoP"] ),

                            DBhelper.SetParameter("@app_AgreePrivacyCredit", context.Request.QueryString["app_AgreePrivacyCredit"] ),
                            DBhelper.SetParameter("@app_Title1", context.Request.QueryString["app_Title1"] ),
                            DBhelper.SetParameter("@app_Title2", context.Request.QueryString["app_Title2"] ),

                            DBhelper.SetParameter("@app_Mobile1", context.Request.QueryString["app_Mobile1"] ),
                            DBhelper.SetParameter("@app_Mobile2", context.Request.QueryString["app_Mobile2"] ),
                            DBhelper.SetParameter("@app_Phone1", context.Request.QueryString["app_Phone1"] ),

                            DBhelper.SetParameter("@app_Phone2", context.Request.QueryString["app_Phone2"] ),
                            DBhelper.SetParameter("@app_EMailAddress1", context.Request.QueryString["app_EMailAddress1"] ),
                            DBhelper.SetParameter("@app_EMailAddress2", context.Request.QueryString["app_EMailAddress2"] ),

                            DBhelper.SetParameter("@app_ResidentialAddress1", context.Request.QueryString["app_ResidentialAddress1"] ),
                            DBhelper.SetParameter("@app_ResidentialAddress2", context.Request.QueryString["app_ResidentialAddress2"] ),
                            DBhelper.SetParameter("@app_Suburb1", context.Request.QueryString["app_Suburb1"] ),

                            DBhelper.SetParameter("@app_Suburb2", context.Request.QueryString["app_Suburb2"] ),
                            DBhelper.SetParameter("@app_State1", context.Request.QueryString["app_State1"] ),
                            DBhelper.SetParameter("@app_State2", context.Request.QueryString["app_State2"] ),

                            
                            DBhelper.SetParameter("@app_Postcode1", context.Request.QueryString["app_Postcode1"] ),
                            DBhelper.SetParameter("@app_Postcode2", context.Request.QueryString["app_Postcode2"] ),
                            DBhelper.SetParameter("@app_DateOfBirth1", context.Request.QueryString["app_DateOfBirth1"] ),

                            DBhelper.SetParameter("@app_DateOfBirth2", context.Request.QueryString["app_DateOfBirth2"] ),
                            DBhelper.SetParameter("@app_DriversLicence1", context.Request.QueryString["app_DriversLicence1"] ),
                            DBhelper.SetParameter("@app_DriversLicence2", context.Request.QueryString["app_DriversLicence2"] ),

                            
                            DBhelper.SetParameter("@app_ResidentialStatus1", context.Request.QueryString["app_ResidentialStatus1"] ),
                            DBhelper.SetParameter("@app_ResidentialStatus2", context.Request.QueryString["app_ResidentialStatus2"] ),
                            DBhelper.SetParameter("@app_BoardingWithName1", context.Request.QueryString["app_BoardingWithName1"] ),

                            DBhelper.SetParameter("@app_BoardingWithName2", context.Request.QueryString["app_BoardingWithName2"] ),
                            DBhelper.SetParameter("@app_LengthOfResidenceYear1", context.Request.QueryString["app_LengthOfResidenceYear1"] ),
                            DBhelper.SetParameter("@app_LengthOfResidenceYear2", context.Request.QueryString["app_LengthOfResidenceYear2"] ),

                            DBhelper.SetParameter("@app_ResidencePeriod1", context.Request.QueryString["app_ResidencePeriod1"] ),
                            DBhelper.SetParameter("@app_ResidencePeriod2", context.Request.QueryString["app_ResidencePeriod2"] ),
                            DBhelper.SetParameter("@app_NumberofDependant1", context.Request.QueryString["app_NumberofDependant1"] ),

                               DBhelper.SetParameter("@app_NumberofDependant2", context.Request.QueryString["app_NumberofDependant2"] ),
                            DBhelper.SetParameter("@app_BankName1", context.Request.QueryString["app_BankName1"] ),
                            DBhelper.SetParameter("@app_BankName2", context.Request.QueryString["app_BankName2"] ),


                                DBhelper.SetParameter("@app_BSB1", context.Request.QueryString["app_BSB1"] ),
                            DBhelper.SetParameter("@app_BSB2", context.Request.QueryString["app_BSB2"] ),
                            DBhelper.SetParameter("@app_AccountNumber1", context.Request.QueryString["app_AccountNumber1"] ),
                               DBhelper.SetParameter("@app_AccountNumber2", context.Request.QueryString["app_AccountNumber2"] ),

                              DBhelper.SetParameter("@app_PurposeOfLoan1", context.Request.QueryString["app_PurposeOfLoan1"] ),
                            DBhelper.SetParameter("@app_OtherPurpose", context.Request.QueryString["app_OtherPurpose"] ),
                            DBhelper.SetParameter("@app_PurposeSummary", context.Request.QueryString["app_PurposeSummary"] ),

                            DBhelper.SetParameter("@app_NameOfPartner1", context.Request.QueryString["app_NameOfPartner1"] ),
                            DBhelper.SetParameter("@app_NameOfPartner2", context.Request.QueryString["app_NameOfPartner2"] ),
                            DBhelper.SetParameter("@app_ContactNumber1", context.Request.QueryString["app_ContactNumber1"] ),
                            DBhelper.SetParameter("@app_ContactNumber2", context.Request.QueryString["app_ContactNumber2"] ),

                            DBhelper.SetParameter("@app_NameOf1stRelative1", context.Request.QueryString["app_NameOf1stRelative1"] ),
                            DBhelper.SetParameter("@app_NameOf1stRelative2", context.Request.QueryString["app_NameOf1stRelative2"] ),
                            DBhelper.SetParameter("@app_RelationshipOf1stRelative1", context.Request.QueryString["app_RelationshipOf1stRelative1"] ),
                            DBhelper.SetParameter("@app_RelationshipOf1stRelative2", context.Request.QueryString["app_RelationshipOf1stRelative2"] ),

                            
                            DBhelper.SetParameter("@app_HomeNumber1st1", context.Request.QueryString["app_HomeNumber1st1"] ),
                            DBhelper.SetParameter("@app_HomeNumber1st2", context.Request.QueryString["app_HomeNumber1st2"] ),
                            DBhelper.SetParameter("@app_NameOf2ndRelative1", context.Request.QueryString["app_NameOf2ndRelative1"] ),
                            DBhelper.SetParameter("@app_NameOf2ndRelative2", context.Request.QueryString["app_NameOf2ndRelative2"] ),


                            DBhelper.SetParameter("@app_RelationshipOf2ndRelative1", context.Request.QueryString["app_RelationshipOf2ndRelative1"] ),
                            DBhelper.SetParameter("@app_RelationshipOf2ndRelative2", context.Request.QueryString["app_RelationshipOf2ndRelative2"] ),
                            DBhelper.SetParameter("@app_HomeNumber2nd1", context.Request.QueryString["app_HomeNumber2nd1"] ),
                            DBhelper.SetParameter("@app_HomeNumber2nd2", context.Request.QueryString["app_HomeNumber2nd2"] ),

                            DBhelper.SetParameter("@app_TypeOfEmployment1", context.Request.QueryString["app_TypeOfEmployment1"] ),
                            DBhelper.SetParameter("@app_TypeOfEmployment2", context.Request.QueryString["app_TypeOfEmployment2"] ),
                            DBhelper.SetParameter("@app_TOE1", context.Request.QueryString["app_TOE1"] ),
                            DBhelper.SetParameter("@app_TOE2", context.Request.QueryString["app_TOE2"] ),

                            DBhelper.SetParameter("@app_BusinessName1", context.Request.QueryString["app_BusinessName1"] ),
                            DBhelper.SetParameter("@app_BusinessName2", context.Request.QueryString["app_BusinessName2"] ),
                            DBhelper.SetParameter("@app_Address1", context.Request.QueryString["app_Address1"] ),
                            DBhelper.SetParameter("@app_Address2", context.Request.QueryString["app_Address2"] ),







                            DBhelper.SetParameter("@app_Phone1", context.Request.QueryString["app_Phone1"] ),
                            DBhelper.SetParameter("@app_EMailAdcontext.Request.QueryStringess1", context.Request.QueryString["applicant_email_adcontext.Request.QueryStringess"] ),
                            DBhelper.SetParameter("@app_ResidentialAdcontext.Request.QueryStringess1", context.Request.QueryString["applicant_resedential_adcontext.Request.QueryStringess"] ),
                            DBhelper.SetParameter("@app_DateOfBirth1", context.Request.QueryString["applicant_dob"] ),
                            DBhelper.SetParameter("@app_context.Request.QueryStringiversLicence1", context.Request.QueryString["applicant_context.Request.QueryStringivers_license"] ),
                            DBhelper.SetParameter("@app_ResidentialStatus1", context.Request.QueryString["applicant_resendential_status"] ),
                            DBhelper.SetParameter("@app_BoardingWithName1", context.Request.QueryString["applicant_boardingwith_name"] ),
                            DBhelper.SetParameter("@app_LengthOfResidenceYear1", context.Request.QueryString["applicant_resedential_length"] ),
                            DBhelper.SetParameter("@app_ResidencePeriod1", context.Request.QueryString["applicant_resedential_period"] ),
                            DBhelper.SetParameter("@app_NumberofDependant1", context.Request.QueryString["applicant_numberof_dependent"] ),
                            DBhelper.SetParameter("@app_PurposeOfLoan1", context.Request.QueryString["application_purpose"] ),
                            DBhelper.SetParameter("@app_otherpurpose", context.Request.QueryString["application_other_purpose"] ),
                            DBhelper.SetParameter("@app_PurposeSummary", context.Request.QueryString["application_purpose_type"] ),
                            DBhelper.SetParameter("@app_TypeOfEmployment1", context.Request.QueryString["applicant_employment_type"] ),
                            DBhelper.SetParameter("@app_BusinessName1", context.Request.QueryString["applicant_business_name"] ),
                            DBhelper.SetParameter("@app_Adcontext.Request.QueryStringess1", context.Request.QueryString["applicant_business_adcontext.Request.QueryStringess"] ),
                            DBhelper.SetParameter("@app_AbnNumber1", context.Request.QueryString["applicant_business_abn"] ),
                            DBhelper.SetParameter("@app_NatureOfBusiness1", context.Request.QueryString["applicant_business_nature"] ),
                            DBhelper.SetParameter("@app_moneydetail1", context.Request.QueryString["applicant_business_money_details"] ),
                            DBhelper.SetParameter("@app_NameOfDirectors1", context.Request.QueryString["applicant_business_directors_name"] ),
                            DBhelper.SetParameter("@app_IncomeAfterTax1", context.Request.QueryString["applicant_income_aftertax"] ),
                            DBhelper.SetParameter("@app_incomeAfterTax1Period", context.Request.QueryString["applicant_income_aftertax_period"] ),
                            DBhelper.SetParameter("@app_CentrelinkIncome1", context.Request.QueryString["applicant_income_centrelink"] ),
                            DBhelper.SetParameter("@app_OtherIncomeSpecify1", context.Request.QueryString["applicant_income_other"] ),
                            DBhelper.SetParameter("@app_RentalIncome1", context.Request.QueryString["applicant_income_rental"] ),
                            DBhelper.SetParameter("@app_TotalIncome", context.Request.QueryString["applicant_income_total"] ),
                            DBhelper.SetParameter("@app_Vehicle1Value", context.Request.QueryString["applicant_vechicle_value"] ),
                            DBhelper.SetParameter("@app_Vehicle1Payment", context.Request.QueryString["applicant_vechicle_finance"] ),
                            DBhelper.SetParameter("@app_Vehicle1Owner", context.Request.QueryString["applicant_vechicle_owner"] ),
                            DBhelper.SetParameter("@app_Property1Adcontext.Request.QueryStringess", context.Request.QueryString["applicant_property_adcontext.Request.QueryStringess"] ),
                            DBhelper.SetParameter("@app_Property1LandSize", context.Request.QueryString["applicant_property_landsize"] ),
                            DBhelper.SetParameter("@app_browser", context.Request.QueryString["application_browser"] ),
                            DBhelper.SetParameter("@app_ipadcontext.Request.QueryStringess", context.Request.QueryString["application_ipadcontext.Request.QueryStringess"] ),
                            DBhelper.SetParameter("@app_referrerName", context.Request.QueryString["application_referrer_name"] ),
                            DBhelper.SetParameter("@app_referrerCompany", context.Request.QueryString["application_referrer_company"] ),
                            DBhelper.SetParameter("@app_referrerEmail", context.Request.QueryString["application_referrer_email"] ),
                            DBhelper.SetParameter("@app_status", context.Request.QueryString["application_status"] ),
                            DBhelper.SetParameter("@app_ela", string.Empty),
                            DBhelper.SetParameter("@app_FirstName2", string.Empty),
                            DBhelper.SetParameter("@app_Surname2", string.Empty),
                            DBhelper.SetParameter("@app_Residency2", string.Empty),
                            DBhelper.SetParameter("@app_AoP",string.Empty),
                            DBhelper.SetParameter("@app_InvestmentBank_all", string.Empty),
                            DBhelper.SetParameter("@app_Property1Register1", string.Empty),
                            DBhelper.SetParameter("@app_Propery1RegValue1", string.Empty),
                            DBhelper.SetParameter("@app_Property1Register2", string.Empty),
                            DBhelper.SetParameter("@app_Propery1RegValue2",string.Empty),
                            DBhelper.SetParameter("@app_Property2Register1", string.Empty),
                            DBhelper.SetParameter("@app_Propery2RegValue1", string.Empty),
                            DBhelper.SetParameter("@app_Property2Register2", string.Empty),
                            DBhelper.SetParameter("@app_Propery2RegValue2", string.Empty),
                            DBhelper.SetParameter("@app_Property3Register1", string.Empty),
                            DBhelper.SetParameter("@app_Propery3RegValue1", string.Empty),
                            DBhelper.SetParameter("@app_Property3Register2", string.Empty),
                            DBhelper.SetParameter("@app_Propery3RegValue2", string.Empty),
                            DBhelper.SetParameter("@app_Property4Register1", string.Empty),
                            DBhelper.SetParameter("@app_Propery4RegValue1", string.Empty),
                            DBhelper.SetParameter("@app_Property4Register2", string.Empty),
                            DBhelper.SetParameter("@app_Propery4RegValue2", string.Empty),
                            DBhelper.SetParameter("@app_morarr1", string.Empty),
                            DBhelper.SetParameter("@app_morarr2", string.Empty),
                            DBhelper.SetParameter("@app_monarr1", string.Empty),
                            DBhelper.SetParameter("@app_monarr2", string.Empty),
                            DBhelper.SetParameter("@app_PropertyPostcode_all", string.Empty),
                            DBhelper.SetParameter("@app_Date", DateTime.Now),
                            DBhelper.SetParameter("@app_Time", DateTime.Now.TimeOfDay),
                            DBhelper.SetParameter("@app_damount", string.Empty),
                            DBhelper.SetParameter("@app_IncomeStatus", string.Empty),
                            DBhelper.SetParameter("@app_AssetStatus", string.Empty),
                            DBhelper.SetParameter("@app_CreditStatus", string.Empty),
                            DBhelper.SetParameter("@app_callstatus", string.Empty),
                            DBhelper.SetParameter("@app_emailFollowup", string.Empty),
                            DBhelper.SetParameter("@app_suburb", string.Empty),
                            DBhelper.SetParameter("@app_MortgageOwing", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment", string.Empty),
                            DBhelper.SetParameter("@app_MortgageBank", string.Empty),
                            DBhelper.SetParameter("@app_LivingExpensesPayment", string.Empty),
                            DBhelper.SetParameter("@app_PersonalLoanOwing", string.Empty),
                            DBhelper.SetParameter("@app_PersonalLoanPayment", string.Empty),
                            DBhelper.SetParameter("@app_PersonalLoanBank", string.Empty),
                            DBhelper.SetParameter("@app_CarLoanOwing", string.Empty),
                            DBhelper.SetParameter("@app_CarLoanPayment", string.Empty),
                            DBhelper.SetParameter("@app_CarLoanBank", string.Empty),
                            DBhelper.SetParameter("@app_CreditCardOwing", string.Empty),
                            DBhelper.SetParameter("@app_CreditCardPayment", string.Empty),
                            DBhelper.SetParameter("@app_CreditCardBank", string.Empty),
                            DBhelper.SetParameter("@app_PaydayLoanOwing", string.Empty),
                            DBhelper.SetParameter("@app_PaydayLoanPayment", string.Empty),
                            DBhelper.SetParameter("@app_PaydayLoanBank", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoan1", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanOwing1", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanPayment1", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanBank1", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoan2", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanOwing2", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanPayment2", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanBank2", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoan3", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanOwing3", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanPayment3", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanBank3", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoan4", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanOwing4", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanPayment4", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanBank4", string.Empty),
                            DBhelper.SetParameter("@app_Vehicle3Value", string.Empty),
                            DBhelper.SetParameter("@app_Vehicle3Owner", string.Empty),
                            DBhelper.SetParameter("@app_Motor3Make", string.Empty),
                            DBhelper.SetParameter("@app_Motor3Finance", string.Empty),
                            DBhelper.SetParameter("@app_Motor3Model", string.Empty),
                            DBhelper.SetParameter("@app_Motor3Transmission", string.Empty),
                            DBhelper.SetParameter("@app_Motor3Year", string.Empty),
                            DBhelper.SetParameter("@app_Motor3Insurance", string.Empty),
                            DBhelper.SetParameter("@app_Vehicle4Value", string.Empty),
                            DBhelper.SetParameter("@app_Vehicle4Owner", string.Empty),
                            DBhelper.SetParameter("@app_Motor4Make", string.Empty),
                            DBhelper.SetParameter("@app_Motor4Finance", string.Empty),
                            DBhelper.SetParameter("@app_Motor4Model", string.Empty),
                            DBhelper.SetParameter("@app_Motor4Transmission", string.Empty),
                            DBhelper.SetParameter("@app_Motor4Year", string.Empty),
                            DBhelper.SetParameter("@app_Motor4Insurance", string.Empty),
                            DBhelper.SetParameter("@app_Property3Value", string.Empty),
                            DBhelper.SetParameter("@app_Property3Payment", string.Empty),
                            DBhelper.SetParameter("@app_Property3Bank", string.Empty),
                            DBhelper.SetParameter("@app_Property3Owner", string.Empty),
                            DBhelper.SetParameter("@app_Property3Adcontext.Request.QueryStringess", string.Empty),
                            DBhelper.SetParameter("@app_Property3Debt1st", string.Empty),
                            DBhelper.SetParameter("@app_Property3State", string.Empty),
                            DBhelper.SetParameter("@app_morarr3", string.Empty),
                            DBhelper.SetParameter("@app_monarr3", string.Empty),
                            DBhelper.SetParameter("@app_Property3Postcode", string.Empty),
                            DBhelper.SetParameter("@app_Property3Debt2nd", string.Empty),
                            DBhelper.SetParameter("@app_Property3Type", string.Empty),
                            DBhelper.SetParameter("@app_Property3Caveat", string.Empty),
                            DBhelper.SetParameter("@app_Property3Description", string.Empty),
                            DBhelper.SetParameter("@app_Property3LandSize", string.Empty),
                            DBhelper.SetParameter("@app_Property3Becontext.Request.QueryStringooms", string.Empty),
                            DBhelper.SetParameter("@app_Property3Bathrooms", string.Empty),
                            DBhelper.SetParameter("@app_Property4Value", string.Empty),
                            DBhelper.SetParameter("@app_Property4Payment", string.Empty),
                            DBhelper.SetParameter("@app_Property4Bank", string.Empty),
                            DBhelper.SetParameter("@app_Property4Owner", string.Empty),
                            DBhelper.SetParameter("@app_Property4Adcontext.Request.QueryStringess", string.Empty),
                            DBhelper.SetParameter("@app_Property4Debt1st", string.Empty),
                            DBhelper.SetParameter("@app_Property4State", string.Empty),
                            DBhelper.SetParameter("@app_morarr4", string.Empty),
                            DBhelper.SetParameter("@app_monarr4", string.Empty),
                            DBhelper.SetParameter("@app_Property4Postcode", string.Empty),
                            DBhelper.SetParameter("@app_Property4Debt2nd", string.Empty),
                            DBhelper.SetParameter("@app_Property4Type", string.Empty),
                            DBhelper.SetParameter("@app_Property4Caveat", string.Empty),
                            DBhelper.SetParameter("@app_Property4Description", string.Empty),
                            DBhelper.SetParameter("@app_Property4LandSize", string.Empty),
                            DBhelper.SetParameter("@app_Property4Becontext.Request.QueryStringooms", string.Empty),
                            DBhelper.SetParameter("@app_Property4Bathrooms", string.Empty),
                            DBhelper.SetParameter("@app_BikeValue1", string.Empty),
                            DBhelper.SetParameter("@app_BikeMake1", string.Empty),
                            DBhelper.SetParameter("@app_BikeModel1", string.Empty),
                            DBhelper.SetParameter("@app_BikeOwner1", string.Empty),
                            DBhelper.SetParameter("@app_BikeFinance1", string.Empty),
                            DBhelper.SetParameter("@app_BikeYear1", string.Empty),
                            DBhelper.SetParameter("@app_BikeInsurance1", string.Empty),
                            DBhelper.SetParameter("@app_GeneralForm", string.Empty),
                            DBhelper.SetParameter("@app_TotalPayment", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment1", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment2", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment3", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment4", string.Empty),
                            DBhelper.SetParameter("@app_BusinessName", string.Empty),
                            DBhelper.SetParameter("@app_AbnNumber", string.Empty),
                            DBhelper.SetParameter("@app_NatureOfBusiness", string.Empty),
                            DBhelper.SetParameter("@app_Adcontext.Request.QueryStringess", string.Empty),
                            DBhelper.SetParameter("@app_MoneyDetail", string.Empty),
                            DBhelper.SetParameter("@app_NameOfDirectors", string.Empty),
                            DBhelper.SetParameter("@app_Property1OtherMortgage1", string.Empty),
                            DBhelper.SetParameter("@app_Property1OtherMortgage2", string.Empty),
                            DBhelper.SetParameter("@app_Property2OtherMortgage1", string.Empty),
                            DBhelper.SetParameter("@app_Property2OtherMortgage2", string.Empty),
                            DBhelper.SetParameter("@app_Property3OtherMortgage1", string.Empty),
                            DBhelper.SetParameter("@app_Property3OtherMortgage2", string.Empty),
                            DBhelper.SetParameter("@app_Property4OtherMortgage1", string.Empty),
                            DBhelper.SetParameter("@app_Property4OtherMortgage2", string.Empty),
                            DBhelper.SetParameter("@app_LowestLivingExpensesPayment", string.Empty),
                            DBhelper.SetParameter("@app_NoticeOnDBView", string.Empty),
                            DBhelper.SetParameter("@app_CorrectTotalPayment", string.Empty),
                            DBhelper.SetParameter("@app_LVR1", string.Empty),
                            DBhelper.SetParameter("@app_LVR2", string.Empty),
                            DBhelper.SetParameter("@app_LVR3", string.Empty),
                            DBhelper.SetParameter("@app_LVR4", string.Empty),
                            DBhelper.SetParameter("@app_BoardingRentingFee", string.Empty),
                            DBhelper.SetParameter("@app_url", string.Empty),
                            DBhelper.SetParameter("@app_usbMonth", string.Empty),
                            DBhelper.SetParameter("@app_usbYear", string.Empty),
                            DBhelper.SetParameter("@app_usbCashSale", string.Empty),
                            DBhelper.SetParameter("@app_usbEftposSale", string.Empty),
                            DBhelper.SetParameter("@app_usbbizstatus", string.Empty),
                            DBhelper.SetParameter("@app_isUsb", string.Empty),
                            DBhelper.SetParameter("@app_Property5Value", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment5", string.Empty),
                            DBhelper.SetParameter("@app_Property5Bank", string.Empty),
                            DBhelper.SetParameter("@app_Property5Owner", string.Empty),
                            DBhelper.SetParameter("@app_Property5Adcontext.Request.QueryStringess", string.Empty),
                            DBhelper.SetParameter("@app_Property5Debt1st", string.Empty),
                            DBhelper.SetParameter("@app_Property5OtherMortgage1", string.Empty),
                            DBhelper.SetParameter("@app_Property5OtherMortgage2", string.Empty),
                            DBhelper.SetParameter("@app_Property5State", string.Empty),
                            DBhelper.SetParameter("@app_morarr5", string.Empty),
                            DBhelper.SetParameter("@app_monarr5", string.Empty),
                            DBhelper.SetParameter("@app_Property5Postcode", string.Empty),
                            DBhelper.SetParameter("@app_Property5Type", string.Empty),
                            DBhelper.SetParameter("@app_Property5Description", string.Empty),
                            DBhelper.SetParameter("@app_Property5LandSize", string.Empty),
                            DBhelper.SetParameter("@app_Property5Becontext.Request.QueryStringooms", string.Empty),
                            DBhelper.SetParameter("@app_Property5Bathrooms", string.Empty),
                            DBhelper.SetParameter("@app_LVR5", string.Empty),
                            DBhelper.SetParameter("@app_Property6Value", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment6", string.Empty),
                            DBhelper.SetParameter("@app_Property6Bank", string.Empty),
                            DBhelper.SetParameter("@app_Property6Owner", string.Empty),
                            DBhelper.SetParameter("@app_Property6Adcontext.Request.QueryStringess", string.Empty),
                            DBhelper.SetParameter("@app_Property6Debt1st", string.Empty),
                            DBhelper.SetParameter("@app_Property6OtherMortgage1", string.Empty),
                            DBhelper.SetParameter("@app_Property6OtherMortgage2", string.Empty),
                            DBhelper.SetParameter("@app_Property6State", string.Empty),
                            DBhelper.SetParameter("@app_morarr6", string.Empty),
                            DBhelper.SetParameter("@app_monarr6", string.Empty),
                            DBhelper.SetParameter("@app_Property6Postcode", string.Empty),
                            DBhelper.SetParameter("@app_Property6Type", string.Empty),
                            DBhelper.SetParameter("@app_Property6Description", string.Empty),
                            DBhelper.SetParameter("@app_Property6LandSize", string.Empty),
                            DBhelper.SetParameter("@app_Property6Becontext.Request.QueryStringooms", string.Empty),
                            DBhelper.SetParameter("@app_Property6Bathrooms", string.Empty),
                            DBhelper.SetParameter("@app_LVR6", string.Empty),
                            DBhelper.SetParameter("@app_BeneficiaryName", string.Empty),
                            DBhelper.SetParameter("@app_preappcode", string.Empty),
                            DBhelper.SetParameter("@app_WhyChooseMF", string.Empty),
                            DBhelper.SetParameter("@app_sendfrom", string.Empty),
                            DBhelper.SetParameter("@app_totalOutstanding", string.Empty),
                            DBhelper.SetParameter("@app_totalOutstanding1", string.Empty),
                            DBhelper.SetParameter("@app_totalOutstanding2", string.Empty),
                            DBhelper.SetParameter("@app_afterpage", string.Empty),
                            DBhelper.SetParameter("@app_OtherIncomePeriod1", string.Empty),
                            DBhelper.SetParameter("@app_OtherIncomePeriod2", string.Empty)
                            };

         
        }
    }
}